﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using Trangtrai.Controller.Global;
using System.Data.SqlClient;

namespace Trangtrai.CauhinhController
{
    public class SeasonController
    {
        public static void InsertSeason(String season_name, String startDate, String endDate, String note)
        {
            if (ConnectionClass.ConnectToDB())
            {
                SqlCommand insertCmd = new SqlCommand("INSERT INTO SEASON (SEASON_NAME, START_DATE, END_DATE, NOTE) VALUES ('"+season_name+"','"+
                    startDate+"','"+endDate+"','"+note+"')",ConnectionClass.sqlConn);

                insertCmd.ExecuteNonQuery();
                ConnectionClass.closeConn();
            }
        }
    }
}